Display from string

[sirdon]

Hi all,

See attached.

In cell M4:N5 they add up total numbers

cell T4 is a formula that refers to M4:M5 and Q3. However, cell T4 seems to display the incorrect answer based on the written formula. I think this is because the cells M4:M5 are not being regarded as values as i have zero numbers to be displayed as empty cell.

Is there a way around this?

Thanks,

[WideBoyDixon]

You could throw ISNUMBER into the mix to trap the blank cells:

Please Login or Register  to view this content.

WBD

[Fluff13]

How about

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[josephteh]

Another formula:=IF(AND(N($M$4)>=$Q$3,N($M$5)>=$Q$3),", ","ppp")

[Bo_Ry]

Please try

=IF(SUM(M4:M5)<Q3*2,"ppp",", ")