How to use the IF formula to return a number

Kiwi971 · #1 05-30-2021, 08:11 AM

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

Marcia · #2 05-30-2021, 06:05 PM

Try replacing the red xxxx to C4-$A$1
Remove the open parenthesis before the IF

Kiwi971 · #3 05-30-2021, 08:13 PM

Quote:

Originally Posted by Marcia

Try replacing the red xxxx to C4-$A$1
Remove the open parenthesis before the IF

Yes, that's exactly what I did. Thank you for your reply. Sometimes I overthink things

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