I have a spreadsheet I'm trying to calculate fees and such with but instead of having 10 columns for calculating I want to condense it.
Can I input something like this in excel and get it to work? It's giving me errors right now.
=IF((u3*0.12)<1, "1", (=sumproduct(u3*0.12)+u3))
-
The value in
u3is a sum of 4 other rows -
U3is a sum of costs. -
I need
12%of the costs ofu3and if it's less than 1, I need theu3sum + 1. If the valueu3*0.12is>1I want the valueu3+(u3*0.12)printed.
Sorry if I'm being redundant, I just want this thing to work
Aucun commentaire:
Enregistrer un commentaire