Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If Greater than when a formula Results in N/A
I have a formula that will result in N/A three quarters of the year. In the
4th quarter, the survey is completed and if the survey rating is greater than 90%, I want to award a certain number of points to the task. How is this done using the IF function considering text (the N/A) is considered greater than 90%. The formula is awarding the points when N/A is the result during the 1st three quarters. =IF(R20=0.9,J20,0) The AVERAGE Formula (using an If function for no denominator) resulting in N/A is in cell R20. The points to be awarded are located in J20 Any help would be appreciated. Thanks, |
#2
|
|||
|
|||
=IF(ISERROR(R20),"",IF(R20=0.9,J20,0))
-- HTH RP (remove nothere from the email address if mailing direct) "John" wrote in message ... I have a formula that will result in N/A three quarters of the year. In the 4th quarter, the survey is completed and if the survey rating is greater than 90%, I want to award a certain number of points to the task. How is this done using the IF function considering text (the N/A) is considered greater than 90%. The formula is awarding the points when N/A is the result during the 1st three quarters. =IF(R20=0.9,J20,0) The AVERAGE Formula (using an If function for no denominator) resulting in N/A is in cell R20. The points to be awarded are located in J20 Any help would be appreciated. Thanks, |
#3
|
|||
|
|||
Hi
try =IF(N(R20)=0.9,J20,0) If you have a text value 'N/A' in your cell -- Regards Frank Kabel Frankfurt, Germany "John" schrieb im Newsbeitrag ... I have a formula that will result in N/A three quarters of the year. In the 4th quarter, the survey is completed and if the survey rating is greater than 90%, I want to award a certain number of points to the task. How is this done using the IF function considering text (the N/A) is considered greater than 90%. The formula is awarding the points when N/A is the result during the 1st three quarters. =IF(R20=0.9,J20,0) The AVERAGE Formula (using an If function for no denominator) resulting in N/A is in cell R20. The points to be awarded are located in J20 Any help would be appreciated. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Excell only displays the formula, not the results | Excel Discussion (Misc queries) | |||
How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions |