Excel - Conditional Formatting - how can I find easy to use instructions?

Question

Specifically I need:
If I put a figure in cell A1 then I want cell B1 to multiply the first cell by a common or designated figure/amount say 3.75
However if a put the letter E in the cell A1 then I want cell B1 to multiply the first cell by a different common or designated figure/amount say 8.00

Answer 1

Here's help - online, free:
http://www.auditexcel.co.za/FAQ.html

Answer 2

=IF( ISERROR( FIND("E",A1)),A1*3.75,( SUBSTITUTE(A1,"E","")*8))

Hoping I got your problem right, you could enter, for example:
12.23E
E12
6 E
12
12.34

But these next entries would not work:
S12
e23
23e

*** Be careful that if you enter a number followed by en E, excel might take this as a number with an exponant.

Answer 3

= I F ( I S N U M B E R ( A 1 ) , A 1 * 3 . 7 5 , " " ) & I F ( A 1 = " E " , A 1 * 8 , " " )

^^ I think that's it