modified if equation.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try this:

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

Hope this helps.

Pete
 
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.
 
Yeah, cheers Steve.

Pete

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.







- Show quoted text -
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining several cells into single equasion? 1
Need to work out a timesheet with times going into next day (>24 h 5
Average formula 2
IF function with value_if_true and value_if_false as equations 4
Adding Inventory with items on order 2
If, Or function or macro to compare 3 columns of numbers 3
sumproduct issues 1
Spurious Formula Omits Adjacent Cells 2

Back
Top