Notifications
Clear all
Topic starter
Good Afternoon
Can you assist?
I am trying to write a formula on the attached spreadsheet to basically say,
If N5 = 74.99% give Zero, if N5 = 75% give Q7, IF N5 = 90% give R7, IF N5 = 95% give S7, IF N5 = 100% give T7
Please advise
Thanks Jay
Posted : 06/02/2020 8:14 am
Hi Jay
A couple of questions
You don't say where you want the formula to appear?
Are the numbers in columns Q to T supposed to be the percentages?
In the IF statements you have put just = do you mean = or less than? (example if N5<=90 give r7?)O
Probably will be better to use a lookup to a table, but we can do it both ways if you can answer the above questions
Purfleet
Posted : 06/02/2020 8:41 am
