How to use the IF formula to return a number

		Microsoft Office Forums > Microsoft Excel > Excel
How to use the IF formula to return a number

FAQ

Thread Tools

Display Modes

05-30-2021, 08:11 AM

Kiwi971

Windows 10 How to use the IF formula to return a number

Office 2019

Novice

Join Date: May 2021

Location: United Arab Emirates

Posts: 9

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.