#1
|
|||
|
|||
How to use the IF formula to return a number
Hi,
I am using an IF/AND formula. (=IF(AND(C4>=0, C4<=$A$1), "x", XXXX) If the value is (TURE) less than A1 it returns an 'X' - This part is fine! If the value is (FALSE) more than A1, I want it to return how much more than A1 it is. Any help on the last part of this formula would be greatly appreciated |
#2
|
||||
|
||||
Try replacing the red xxxx to C4-$A$1
Remove the open parenthesis before the IF |
#3
|
|||
|
|||
Quote:
Yes, that's exactly what I did. Thank you for your reply. Sometimes I overthink things |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return Page Number of Paragraph Number | SamDsouza | Word VBA | 4 | 03-04-2021 09:37 PM |
Need a formula to return data from second tab to first tab. | Tigs1966 | Excel Programming | 0 | 03-04-2019 06:51 AM |
Excel Match return different row number | kimak | Excel | 1 | 03-01-2017 09:39 AM |
Help with a formula to return a zero | prihia971 | Excel | 1 | 10-06-2016 02:17 AM |
Formula to return a date | caz46 | Excel | 3 | 04-15-2015 08:59 AM |