hi
i know this is very basic...
What i want is when L2 is blank, it will show nothing else this formula..Please Login or Register to view this content.
Thanks so much for the help
hi
i know this is very basic...
What i want is when L2 is blank, it will show nothing else this formula..Please Login or Register to view this content.
Thanks so much for the help
=if(l2="","",if($l$2>25,"proceed","do not proceed"))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
=if($l$2="","",if($l$2>25,"proceed","do not proceed"))
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hello sorry i was wrong. what i want is when the value is of L2 is 0, then it will show blank.
=if(l2=0,"",IF($L$2>25,"PROCEED","DO NOT PROCEED"))
Punnam
Thanks!! worked perfctly
hi,
Thanks for the reputation,
Mark the thread solved by using the thread tools
Punnam Ravi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks