I am creating a spreadsheet that tracks projected revenue based on product
and age.
F5=Product (Apple, Orange, etc) Each product has a different profit margin
G5=Price
H5=Customer Age
I5=Projected Revenue
Age is the deciding factor to calculate costs. My forumla without age is:
I5=IF(F5="Apple",G5*0.055,IF(F5="Orange",G5*0.05,))
My attempted formula with age is:
I5=IF(F5="Apple",IF(H5<=80,G5*0.055,IF(H5>=86,G5*0.0275,G5*.044)))
What am I doing wrong? Should I be using a different formula? Thank you
for
your help.
|
