sbrittain1988
New Member
- Joined
- Oct 27, 2017
- Messages
- 1
Hi There,
I have an IF statement that currently has 10 IF statements within.
=IF(B4="F&B",IF(E4="License",(I4*1.22),IF(E4="Hardware",((I4*1.09)*0.4),IF(E4="SaaS",((I4/G4)*12*3.1),IF(E4="Consulting",I4,0)))),IF(E4="License",(I4*1.22),IF(E4="Hardware",((I4*1.12)*0.375),IF(E4="SaaS",((I4/G4)*12*3.1),IF(E4="Consulting",I4,if(E4="Hosting",I4,0))))))
I currently have within the "SaaS" IF statements a multiplier of 3.1 whereas I am trying to change that so that there are 6 different criteria within each SaaS IF.
If it is under 3, I want to multiply by 0.75, between 3-17 multiply by 3.1, 18-29 multiply by 3.35, 30-41 multiply by 3.6, 42-53 multiply by 3.7 and 54 or above multiply by 3.8.
I have tried the IF(AND( statements with no luck.
Any and all suggestions are GREATLY appreciated!
Thanks all!
I have an IF statement that currently has 10 IF statements within.
=IF(B4="F&B",IF(E4="License",(I4*1.22),IF(E4="Hardware",((I4*1.09)*0.4),IF(E4="SaaS",((I4/G4)*12*3.1),IF(E4="Consulting",I4,0)))),IF(E4="License",(I4*1.22),IF(E4="Hardware",((I4*1.12)*0.375),IF(E4="SaaS",((I4/G4)*12*3.1),IF(E4="Consulting",I4,if(E4="Hosting",I4,0))))))
I currently have within the "SaaS" IF statements a multiplier of 3.1 whereas I am trying to change that so that there are 6 different criteria within each SaaS IF.
If it is under 3, I want to multiply by 0.75, between 3-17 multiply by 3.1, 18-29 multiply by 3.35, 30-41 multiply by 3.6, 42-53 multiply by 3.7 and 54 or above multiply by 3.8.
I have tried the IF(AND( statements with no luck.
Any and all suggestions are GREATLY appreciated!
Thanks all!