formula with IF function needed

RSEKAR

Board Regular
Joined
Oct 18, 2010
Messages
172
Dear Sir,
I am a learner in Excel
I want to have a formula satisfying the following conditions.
I may have numerical data in the C column (with out formula).
In columns O and P I have formulae. I may get numerical data out of formula in both the columns (O and P).
I get “-“ in both columns O and P, If I do not get a numerical values out of formula.
In M column I write the following formula.
=IF(AND(C10<O10,(O10-P10)>C10),”PLUS”,”-“)
This formula results in error message if the columns O and P have “-“
I want to give a condition as
If O10 and P10 contain numerical values then the formula should be executed.
Kindly let me know how to get the value with out error.
I use Excel 2002 and XP
Thanking you,
 
Last edited:
I have modified the formula similar to your last pattern and it is working well

IF(AND(C10 < (N(O10) - N(P10))),"PLUS","-")
Thanking you,
 
Upvote 0

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Forum statistics

Threads
1,224,552
Messages
6,179,487
Members
452,917
Latest member
MrsMSalt

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