I hope this can be done?

alfonsoto1

Board Regular
Joined
Nov 25, 2004
Messages
107
If g15<f15 use the number in f15 in g15,if e15 is>f15 or g15 usethe number in e15 in g15, if g15>e15 and f15 leave the number in g15 as is.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
This is what it should say IF G15<F15 USE THE NUMBER IN F15 IN G15,IF E15 IS>F15 OR G15 USETHE NUMBER IN E15 IN G15, IF G15>E15 AND F15 LEAVE THE NUMBER IN G15 AS IS.
 
Upvote 0
Correction if g15 is less than f15 use the number in f15 in g15,if e15 is dreater than f15 or g15 usethe number in e15 in g15, if g15 is greater than e15 and f15 leave the number in g15 as is.
 
Upvote 0
Just to help the OP with the board software it should read as

IF G15<F15 USE THE NUMBER IN F15 IN G15,IF E15 IS>F15 OR G15 USE THE NUMBER IN E15 IN G15, IF G15>E15 AND F15 LEAVE THE NUMBER IN G15 AS IS

Edit: I see the OP has realised the issue and put the less than in words now :)
 
Last edited:
Upvote 0
I'm a bit confused as the way I am reading this you are putting the formula in G15 but testing G15 in the formula. That would cause a circular reference error. please can you clarify?
g15 is less than f15 use the number in f15 in g15
 
Upvote 0
Instead of putting the formula G15 lets put the formula and answers in G18 but leave the rest of the formula as is if possible.
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top