Hello!
I only want the over/under column F, to show a figure result, if either column C (sales gst) or E (disbursements) have data inputted. Otherwise I want it to read $0.00
attached file here..
targets_over.under.xlsx
kind regards..
Hello!
I only want the over/under column F, to show a figure result, if either column C (sales gst) or E (disbursements) have data inputted. Otherwise I want it to read $0.00
attached file here..
targets_over.under.xlsx
kind regards..
Here!
In F2
=IF(MAX(C2,E2)>0,SUM((D2-E2)-B2),0) and drag down
Cheers!
Deep Dave
A few tips before I help with your question.
You dont need to use SUM() unless you are adding up a range of values
=SUM(C2*0.9) cab just be =C2*0.9
=SUM((D2-E2)-B2) can just be =D2-E2-B2
OK...
you stated that if EITHER C or E have data (in other words >0?), so try this...
=IF(OR(C2>0,E2>0),0,D2-E2-B2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thankyou awesome this works perfectly !
FDibbins, thanks for the support and good advice,
just (for others learning from this resource) the formula is right in calculation but needs true false values swapped, so: =IF(OR(C2>0,E2>0),D2-E2-B2,0)
happy to help, I kinda figured I may have them the wrong way round, but once you have the basis, the rest is easier, so thanks for the update
Also, thanks for the rep, always appreciated
Glad it helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks