AdamAU
New Member
- Joined
- Sep 15, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
I am trying to get a excel formula to display a certain text if a cell value is greater than a number and include it in the formula i currently have below. I must keep the formula below, so just want to incorporate another step i guess in this formula.
=IF(EG34<=50.61,"Fail",IF(AND(EG34>=50.61,EG34<52.62),"Pass with Error"))
All i need is to be able to include is if cell eg34 value is greater than 52 then it will display "Pass".
currently the cell is just displaying FALSE but i need it to display PASS based on is the other cell is greater than a number/value.
How can i incorporate that into the above formula? Every time i have tried it won't work.
=IF(EG34<=50.61,"Fail",IF(AND(EG34>=50.61,EG34<52.62),"Pass with Error"))
All i need is to be able to include is if cell eg34 value is greater than 52 then it will display "Pass".
currently the cell is just displaying FALSE but i need it to display PASS based on is the other cell is greater than a number/value.
How can i incorporate that into the above formula? Every time i have tried it won't work.