View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveDB1 SteveDB1 is offline
external usenet poster
 
Posts: 414
Default modified if equation.

Hi all.
I'm interested in doing an if equation that will have a statement inlcuded
in my false answer.
I.e.,
=if(a1=e1,"ok","Amount short by: " a1-e1)
And for the false, my answer would become:
Amount short by: ....
Is it possible to do this?
I've tried with the above form and of course it doesn't work.
Thanks for your responses.