Hi,
I have the fol. fata:
A
1 Ordered Speed
2 16
3 0
I created the fol. formula:
=IF(A2=0, "ECONOMICAL")
=IF(A3=0, "ECONOMICAL")
I have the fol. result:
FALSE
ECONOMICAL
I however want to show value 16 in the cell A2 but not the "FALSE".
Would be the most grateful for any assistance on this
Thanks
Lyudmyla
Try
=IF(A2=0, "ECONOMICAL",A2)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You need to provide a result for both parts of the IF statement. If you wanted nothing to show up, you'd use:
Please Login or Register to view this content.
Last edited by shg; 12-22-2009 at 02:54 PM. Reason: Deleted spurious quote
Magic, thank you very muchOriginally Posted by NBVC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks