I am looking for an IF statement that would leave a balance cell blank if both the revenue and expense cells are blank, otherwise a formula would be calculated.
I am looking for an IF statement that would leave a balance cell blank if both the revenue and expense cells are blank, otherwise a formula would be calculated.
=IF(AND(REV_CELL="", EXP_CELL=""), "", Calculate formula goes here)
Have fuin
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
did't refreshed and posted !(Deleted Post)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thank you judgeh59, that works! Do you know of a way to write the IF statement without using and?
=IF(COUNT(REV_CELL,EXP_CELL)=2, Calculate, "")
Just curious as to why you don't like AND?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
try below works as and only
=IF((REV_CELL="")*(EXP_CELL="")), "", Calculate formula goes here)
I am trying to write the formula in the simplest form possible.
I ended up using this formula and it worked: =IF(C5&D5="","",E4+C5-D5)
well I'm glad you were able to figure out....just another way of doing things in XL....have a great day....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks