IF formula based on 4 criterias

oneleg

New Member
Joined
Feb 5, 2018
Messages
6
Hello,

I have an Excel document where cell F35 sums up the total from cells F25:F34.

Based on the result, I'm trying to, in cell F36, have a different value based on the following criterias:
  • If the value of F35 is 0, I wish to have 0 in cell F36
  • If the value of F35 is 1, I wish to have 45 in cell F36
  • If the value of F35 is either 2, 3 or 4, I wish to have 60 in cell F36
  • If the value of F35 is 5 or greater, I wish to have 80 in cell F36

What is the formula to make this happen ?

Thanks in advance...
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Weazel

Well-known Member
Joined
Dec 24, 2011
Messages
3,155
maybe something like...

=IF(F35=0,0,IF(F35=1,45,IF(F35<5,60,80)))
 

Watch MrExcel Video

Forum statistics

Threads
1,108,768
Messages
5,524,787
Members
409,600
Latest member
Dunnowhatfor

This Week's Hot Topics

Top