I have a column that if I add number to it B4, it must then show data in C4, but if it is blank it must show blank in c$ (that part I did get to work, but now if I have a number in E4 it must then not show anything in C4, so it must not do B3-B4.
I am not sure if I am on the correct track, did try this formula, but not working
=IF(ISBLANK(B4)*(NOT(ISBLANK(E4)),,B3-B4))
Do you mean this?
=IF(AND(B4="",E4<>""),"",B3-B4)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi No it still show value in C4 when there is data in E4
There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
You could try this:
=IF(OR(B4="",E4<>""),"",B3-B4)
but I am really not sure and would prefer to see some worked examples.
it is in google sheets, must i give the link to the file
Thank you, this is working for me
I won't follow links, but you've posted in the wrong place, so I'll move the thread for you. Did you try the suggesrion in my last post?
You need to give examples of what you want if B4 and E4 are blank, neither is blank, etc.
Now I'm confused - you have marked the thread as solved.
OK - thanks. Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks