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.

modified if equation.
 

Perhaps:-

=IF(A1=E1,"OK","Amount short by: " & A1-E1)

Mike

"SteveDB1" wrote:

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.

modified if equation.
 

Try this:

=if(a1=e1,"ok","Amount short by: " & a1-e1)

Hope this helps.

Pete

On Sep 20, 5:06 pm, SteveDB1
wrote:
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.

modified if equation.
 

doh!
why I didn't think about that, I'll never know.
I think that I once tried &&, and it gave me an error....
Thanks guys.
It works great.
Have a great day, evening, and weekend.


"Pete_UK" wrote:

Try this:

=if(a1=e1,"ok","Amount short by: " & a1-e1)

Hope this helps.

Pete

On Sep 20, 5:06 pm, SteveDB1
wrote:
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.

modified if equation.
 

Yeah, cheers Steve.

Pete

On Sep 20, 5:48 pm, SteveDB1
wrote:
doh!
why I didn't think about that, I'll never know.
I think that I once tried &&, and it gave me an error....
Thanks guys.
It works great.
Have a great day, evening, and weekend.



"Pete_UK" wrote:
Try this:

=if(a1=e1,"ok","Amount short by: " & a1-e1)

Hope this helps.

Pete

On Sep 20, 5:06 pm, SteveDB1
wrote:
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.- Hide quoted text -

- Show quoted text -