Computer Excel

[SammyH]

Are there any members on here that understand the workings of formulas in Excel ?

[geordie1234]

Are there any members on here that understand the workings of formulas in Excel ?

 

Yes what do you need to know? Or what are you looking to do

Edited April 20, 2020 by geordie1234

[SammyH]

Yes what do you need to know? Or what are you looking to do

Dinny ken how to PM you so just putting it down here. I'm building a spreadsheet and 1 of the columns I need to change the value of the number. The columns are ( T ) & ( U )

The formula I am trying to put in is =if(t5<=500,0,if(t5<=365,1,if(t5<=84,2,if(t5<=56,3,if(tf5<=42,4,))))) etc. CHEERS

[Guest mambo]

www.excelforum.com

[glencameron]

If you have excel 2016 and above use the IFS function

 

Use the IFS function to test multiple conditions and return a value corresponding to the first TRUE result. Unlike the IF function, IFS allows you to test more than one condition without nesting. This makes makes formulas with many conditions easier to read

 

 

=IFS(A1<43,"4",A1<57,"3",A1<85,â€2â€,A1<365,â€1â€,A1>=366,â€0â€)

 

Replace A with T on the u column

 

 

 

https://exceljet.net/excel-functions/excel-ifs-function

 

Not tested it out but will send link if I have some syntax wrong . If you can’t use ifs and need the nested ifs let me know

 

As an aside the first condition found stops the ifs Or if conditions so in your above I would reverse the conditions as all number will be less than 500