If formula not returning correct results

hi all

im just a little stuck im using this formula

=IF(B5<>"",IF(D5>=0.01,D5,IF(F5>=0.01,F5,"")))

basically if there is a total in "D5" then give total in "D5", if not it should give me the total in "F5" otherwise a blank

instead its returning "FALSE"

Try it this way in E5:

=IF(D5>=0.01,D5,IF(F5>=0.01,F5,""))

then copy down.

Hope this helps.

Pete

@AliGW Thank you - That gets rid of the "False" but if "D5" is blank it should give me total in "F5" but it just returns a blank but thank you

Ali,

that would return the numbers as text values.

Pete

@AliGW very close only thing it omits the 00 after the decimal

example total in "D5" is 600.00 it returns 600

@pete_uk thank you but that returns a blank

@AliGW when if i put if 600.01 it returns 600.01 but if i put in 600.00 it returns 600 not been a pain but i need it to show 600.00 as where im working all figures including the .00 have to be shown

Originally Posted by AliGW

See post #8.

returns #VALUE!

Originally Posted by Patcheen

@pete_uk thank you but that returns a blank

I don't know why my first formula should return a blank for you, but you can try it this way in E5:

=IF(D5<>"",D5,IF(F5<>"",F5,""))

then copy down.

Hope this helps.

Pete

Originally Posted by AliGW

No, it doesn't.

Ali,

if D or F contain formulae which return "" if not satisfied, then D5+F5 will return a #VALUE.

Pete

Sorted - Thanks guys as usual ye are brill thank you very much

Well, not quite. If B5 is not empty you would expect a value from either D5 or F5, but if one of those contain a formula-blank then the result would be a blank from D5+F5.

Pete

Thanks for the rep, Patcheen.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete