How can I get rit of the #VALUE! in my formula
If cell A28 = empty then I get a #VALUE! in cell I28
CELL I28: =IF(A28=3,"",G28*H28/100)
How can I get rit of the #VALUE! in my formula
If cell A28 = empty then I get a #VALUE! in cell I28
CELL I28: =IF(A28=3,"",G28*H28/100)
G'day
Try this
=IF(OR(A28=3,A28=""),"",G28*H28/100)
Cheers
RC
Have I made you happy ??? If yes, please make me happy by pressing the Add Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
Thanx ratcat. It work fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks