{{tag>Function Function_List Mathematical Version:v8.5}} ====== NFORMAT ====== ===== Description ===== Formats a number differently depending on its value – whether it is positive, negative or zero. Returns formatted number ===== Syntax ===== ''NFORMAT (number, positive, zero[, negative])'' Cannot be used in the condition of a [[:ref:a_f:a:find|FIND]] action. ===== Parameters ===== expression, such as SUM, format of the positive non-zero value; format of the zero value; optional format of the negative value ===== Returns ===== **Text**: the number formatted with the format that matches its sign (positive, zero or negative). ===== Example ===== <> ===== Related ===== [[ref:a_f:f:af:as_string|AS_STRING]], [[ref:a_f:f:af:round|ROUND]], [[ref:a_f:f:af:sign|SIGN]]