PDA

View Full Version : Formula -



keilah
09-05-2007, 07:18 AM
Hi

How could i change add to the formula,

if(isblank(A1)"-",A1), i want to add the following function here.....

if cell a1 is empty or blank then,,,,,,calculate +c1/+$E5

need to combine the two function as one formula...

rory
09-05-2007, 07:30 AM
=IF(ISBLANK(A1),c1/$E5,A1)

keilah
09-05-2007, 07:34 AM
ok......just on point i forgot to mention mate.....

i do not want to so any zero values would prefer....."-"........need a fourth paramter....

keilah
09-05-2007, 07:36 AM
ignore last statement...........problem solved....

thanks for the feedback...

rory
09-05-2007, 07:37 AM
Format the cells with the Accounting format: it shows "-" instead of "0".