Hi all,
If I want a simple subtraction to take place in cell a3 say between cell a1 and cell a2 yet this is dependant that cell a4 does not have anything in it, ( a date or a text string), what is the most appropriate formula to use?
Hi all,
If I want a simple subtraction to take place in cell a3 say between cell a1 and cell a2 yet this is dependant that cell a4 does not have anything in it, ( a date or a text string), what is the most appropriate formula to use?
=if(a4="",a1-a2,"")
Try:
=IF(A4<>"",A2-A1,"")
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.
Would this also work:
=IF(A4="","",(A2-A1)).
Thanks everyone for the help on this.
Yes it would... it will give you A2-A1 only if A4 is not blankOriginally Posted by Stevie-B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks