Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Modified by... | Excel Discussion (Misc queries) | |||
Last Modified | Excel Worksheet Functions | |||
<HELP modified reference | Excel Worksheet Functions | |||
date modified | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) |