Can anyone translate this into Excelese?

  • Thread starter Thread starter nickxylas
  • Start date Start date
N

nickxylas

I've got a spreadsheet where I need to put an asterisk into a cell
under certain conditions. I know roughly how to do it, but as someone
who has yet to master the finer points of Excel syntax, I am having
trouble putting all the punctuation marks, cell references and
mathematical operators in exactly the right places.

In BASIC (if there's anyone here old enough to remember that), the
formula would go something like:

IF K7-E8>0 AND IF (K7-E8)*J7<100 THEN O7="*" ELSE O7=""

Needless to say, O7 is the cell into which I will actually be putting
the formula. If anyone can put the formula into a form that Excel will
understand, I will be very grateful.
 
In O7:

=IF(AND(K7-E8>0,(K7-E8)*J7<100),"*","")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've got a spreadsheet where I need to put an asterisk into a cell
| under certain conditions. I know roughly how to do it, but as someone
| who has yet to master the finer points of Excel syntax, I am having
| trouble putting all the punctuation marks, cell references and
| mathematical operators in exactly the right places.
|
| In BASIC (if there's anyone here old enough to remember that), the
| formula would go something like:
|
| IF K7-E8>0 AND IF (K7-E8)*J7<100 THEN O7="*" ELSE O7=""
|
| Needless to say, O7 is the cell into which I will actually be putting
| the formula. If anyone can put the formula into a form that Excel will
| understand, I will be very grateful.
|
 
Back
Top