LinkBack URL
About LinkBacks
In the attached sheet, I need a conditional statement that will account for differences in formulas in a column. I'm baffled by AND and OR which I think are involved here. Will be grateful for help.
In the attached sheet, I need a conditional statement that will account for differences in formulas in a column. I'm baffled by AND and OR which I think are involved here. Will be grateful for help.
Last edited by wolfgang713; 06-26-2013 at 01:54 PM.
In J3
=IF(G3="",IF(D3>H3,(H3-D3)*F3+E3,E3),IF(D2>H2,(D2-H2)*F3+E3,E3))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
This is really advanced stuff. All of it actually makes sense even at my level. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks