Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-30-2021, 08:11 AM
Kiwi971 Kiwi971 is offline How to use the IF formula to return a number Windows 10 How to use the IF formula to return a number Office 2019
Novice
How to use the IF formula to return a number
 
Join Date: May 2021
Location: United Arab Emirates
Posts: 9
Kiwi971 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-30-2021, 06:05 PM
Marcia's Avatar
Marcia Marcia is offline How to use the IF formula to return a number Windows 10 How to use the IF formula to return a number Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Try replacing the red xxxx to C4-$A$1
Remove the open parenthesis before the IF
Reply With Quote
  #3  
Old 05-30-2021, 08:13 PM
Kiwi971 Kiwi971 is offline How to use the IF formula to return a number Windows 10 How to use the IF formula to return a number Office 2016
Novice
How to use the IF formula to return a number
 
Join Date: May 2021
Location: United Arab Emirates
Posts: 9
Kiwi971 is on a distinguished road
Default

Quote:
Originally Posted by Marcia View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use the IF formula to return a number 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
How to use the IF formula to return a number Help with a formula to return a zero prihia971 Excel 1 10-06-2016 02:17 AM
How to use the IF formula to return a number 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 04:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft