How do I do this?

D

djarcadian

I have this formula I need an excel spreadsheet to perform. Can anyon
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.06
 
G

Gary''s Student

If cell1 is A1 and cell2 is A2, then put elsewhere

=if(A1+A2<7000,A1+A2*.062,7000-A1*.062)
 
Top