Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help.
Sample Data A B C D 1 | 700 | 800 | =A1/B1 (=87.5%) 2 | 720 | 800 | =A2/B2 (=90%) 3 | 721 | 800 | =A3/B3 (=91%) 4 | 792 | 800 | =A4/B4 (=99%) 5 | 800 | 800 | =A5/B5 (=100%) 6 | 952 | 800 | =A5/B5 (=119%) 7 | 960 | 800 | =A5/B5 (=120%) Here is what I would like cell D1 to do based on the answer in C1. If the answer in cell c1 is less than 90% then return the value in cell C1, but if the cell value in C1 is greater or equal to 90% but less than 100% then add text that states "MTD FCST within 10%", but if the cell value in C1 is greater or equal to 100% but less than 120% then add text that states "MTD FCST exceeds FCST but acceptable", but if the cell value in C1 exceeds 120% then add text that states "Over FCST" Thanks in advance for any help. -- GS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workspace faux user-defined type not defined | Excel Programming | |||
Multi-conditional user defined function | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming | |||
Can I use a User-Defined Funcion in a Conditional Format formula? | Excel Programming |