Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I do this?
I have this formula I need an excel spreadsheet to perform. Can anyone tell me how to do this? I'd greatly appreciate the help. cell1+cell2<$7000 then cell1 + cell2 X 0.062 cell1+cell2$7000 then $7000-cell1 X 0.062 -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=466978 |
#2
|
|||
|
|||
If cell1 is A1 and cell2 is A2, then put elsewhere
=if(A1+A2<7000,A1+A2*.062,7000-A1*.062) -- Gary''s Student "djarcadian" wrote: I have this formula I need an excel spreadsheet to perform. Can anyone tell me how to do this? I'd greatly appreciate the help. cell1+cell2<$7000 then cell1 + cell2 X 0.062 cell1+cell2$7000 then $7000-cell1 X 0.062 -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=466978 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|