Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-course - IF statements
Resolved · Low Priority · Version Standard
John-paul has attended:
Excel Intermediate course
Is there an easy way to get to grips with using multiple IF statements i.e. is there a working example out there that can show me how to string lots of them together?
=IF(A1>100,"high",IF(A1=100,"exact",IF(A1<100,"low","")))
This illustrates how to use multiple if statements together.
if the result is true, then do one thing, otherwise move onto the next thing and so on.
remember to put a close bracket for every open bracket.
|
Excel tip:Calculate age or serviceThe DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip: |
We'll call during UK business hours
Server loaded in 0.11 secs.